Previous Topic

Next Topic

Example: Find total number of pledges by amount

This query extracts the total number of members who have made a pledge of $50 or more.

  1. Browse to IQA.
  2. Select Query from the drop-down list and select New.
  3. Select your sources:
    1. Browse to the Common folder containing business objects.
    2. Select the business objects:
      • Contact
      • CsActivity
  4. Define the filtering rules:
    1. Select the Filters tab.
    2. Filter on Activity.Activity Type:
      • Property: Activity.Activity Type
      • Comparison: Equal
      • Value: PLEDGE
    3. Add the filter.
    4. Filter on Activity.Amount:
      • Property: Activity.Amount
      • Comparison: Greater
      • Value: 50
    5. Add the filter.
  5. Define the columns that display in the output:
    1. Select the Display tab.
      • Mode: Advanced
      • Property: Contact.iMIS Id
      • Function: Count
      • Alias: Pledges
      • Order: 1
    2. Select the Display option.

      Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.

  6. Save your settings.
  7. Run the query.

See Also

Query Examples

Example: Find recipients for e-mail

Example: Find current registrants

Example: Find registered members by city

Example: Find members by company and state

Example: Find purchases by amount and date

Example: Find members by state or join date


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:08 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.